Implementing Data Warehouses on AWS

Back to Home

01. Lesson Introduction
02. Data Warehouse: A Closer Look
03. Choices for Implementing a Data Warehouse
04. DWH Dimensional Model Storage on AWS
05. Amazon Redshift Technology
06. Amazon Redshift Architecture
07. Redshift Architecture Example
08. SQL to SQL ETL
09. SQL to SQL ETL - AWS Case
10. Redshift & ETL in Context
11. Ingesting at Scale
12. Redshift ETL Examples
13. Redshift ETL Continued
14. Redshift Cluster Quick Launcher
15. Exercise 1: Launch Redshift Cluster
16. Problems with the Quick Launcher
17. Infrastructure as Code on AWS
18. Enabling Programmatic Access fo IaC
19. Demo: Infrastructure as Code
20. Exercise 2: Infrastructure as Code
21. Exercise Solution 2: Infrastructure as Code
22. Demo: Parallel ETL
23. Exercise 3: Parallel ETL
24. Exercise Solution 3: Parallel ETL
25. Optimizing Table Design
26. Distribution Style: Even
27. Distribution Style: All
28. Distribution Syle: Auto
29. Distribution Syle: Key
30. Sorting Key
31. Sorting Key Example
32. Demo: Table Design
33. Exercise 4: Table Design
34. Exercise Solution 4: Table Design
35. Conclusion

Back to Home

27. Distribution Style: All

L03-08-OptimizingDesign-Part1 Distribution Syle- All

What does the ALL distribution style do to a table?

Puts all records of a table in the same slice

Replicates a table on all slices

SOLUTION:

Replicates a table on all slices

What's another common name for the ALL distribution style?

Broadcasting

Widecasting

Anycasting

SOLUTION:

Broadcasting

Learn Udacity: click here to learn more :)